<?php
/**
 * @name: HOTN AnimeList
 * @version: 1.0
 * @license: GPLv2
 * @link: http://code.google.com/p/hotnanimelist/
 * 
 * @author: HammerOnTheNail
 * @link: http://hotn.hu/
 */

include(e_PLUGIN."hotn_animelist/Languages/".e_LANGUAGE.".php");

// Plugin info
$eplug_name = "HOTN AnimeList";
$eplug_version = "1.0";
$eplug_author = "HammerOnTheNail";
$eplug_email = 'info@hotn.hu';
$eplug_url = "https://sourceforge.net/projects/animelist-e107p/";
$eplug_compatible = "e107v0.7.18+";

$eplug_folder = "hotn_animelist";
$eplug_menu_name = "hotn_animelist";
$eplug_icon = $eplug_folder."/Images/icon_32.png";
$eplug_icon_small = $eplug_folder."/Images/icon_16.png";

// Státusz menü hasnálata az adminban
$eplug_status = true;

$eplug_link = TRUE;
$eplug_link_name = HOTN_ANIMELIST_DEFAULT_PROJECTS;
$eplug_link_url = $PLUGINS_DIRECTORY."e107_plugins/".$eplug_folder."/project_list.php";

$eplug_description = HOTN_ANIMELIST_PLUGIN_DESCRIPTION; 
$eplug_done = HOTN_ANIMELIST_PLUGIN_DONE;

$eplug_conffile = "Admin/admin_index.php";
$eplug_caption = "HOTN AnimeList";

// MySQL info

$eplug_table_names = array(
	"hotn_animelist_options",
	"hotn_animelist_download",
	"hotn_animelist_error",
	"hotn_animelist_team",
	"hotn_animelist_genre",
	"hotn_animelist_project",
	"hotn_animelist_manga"
);

$eplug_tables = array(
	"CREATE TABLE `".MPREFIX."hotn_animelist_options` (
	  	`hotn_animelist_options_name` VARCHAR( 20 ) NOT NULL ,
		`hotn_animelist_options_value` VARCHAR( 50 ) NOT NULL
	) ENGINE = MYISAM ;",
	"CREATE TABLE `".MPREFIX."hotn_animelist_download` (
		`download_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
		`download_name` VARCHAR( 100 ) NOT NULL ,
		`download_url` VARCHAR( 150 ) NOT NULL ,
		`download_author` INT NOT NULL ,
		`download_filesize` VARCHAR( 20 ) NOT NULL ,
		`download_request` INT NOT NULL ,
		`download_project` INT NOT NULL ,
		`download_type` VARCHAR( 10 ) NOT NUL
		`download_datestamp` INT NOT NULL ,
		`download_episode` INT NOT NULL,
		`download_news` tinyint(1) NOT NULL,
		`download_category` INT NOT NULL
	) ENGINE =  MYISAM ;",
	"CREATE TABLE `".MPREFIX."hotn_animelist_error` (
		`error_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
		`error_title` VARCHAR( 50 ) NOT NULL ,
		`error_text` TEXT NOT NULL ,
		`error_url` VARCHAR( 150 ) NOT NULL,
		`error_datestamp` INT NOT NULL 
	) ENGINE = MYISAM ;",
	"CREATE TABLE `".MPREFIX."hotn_animelist_team` (
		`team_id` INT NOT NULL PRIMARY KEY ,
		`team_do` TEXT NOT NULL,
		`team_email` VARCHAR( 150 ) NOT NULL
	) ENGINE = MYISAM ;",
	"CREATE TABLE `".MPREFIX."hotn_animelist_genre` (
		`project_id` INT NOT NULL ,
		`genre_id` INT NOT NULL
	) ENGINE = MYISAM ;",
	"CREATE TABLE `".MPREFIX."hotn_animelist_project` (
		`project_id` int(11) INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
		`project_type` varchar(10) NOT NULL,
		`project_anime_type` varchar(10) NOT NULL,
		`project_mode` varchar(10) NOT NULL,
		`project_name` varchar(255) NOT NULL,
		`project_folder` varchar(255) NOT NULL,
		`project_eng_name` varchar(255) NOT NULL,
		`project_hun_name` varchar(255) NOT NULL,
  		`project_other_name` text NOT NULL,
  		`project_length` int(11) NOT NULL,
  		`project_files` int(11) NOT NULL,
  		`project_request` INT NOT NULL,
  		`project_text` text NOT NULL,
  		`project_image_reference` varchar(50) NOT NULL,
  		`project_image_news` varchar(50) NOT NULL,
  		`project_image_1` varchar(50) NOT NULL,
  		`project_image_2` varchar(50) NOT NULL,
  		`project_image_3` varchar(50) NOT NULL,
  		`project_image_4` varchar(50) NOT NULL,
  		`project_image_5` varchar(50) NOT NULL,
  		`project_image_6` varchar(50) NOT NULL,
  		`project_anidb` varchar(150) NOT NULL,
  		`project_animenewsnetwork` varchar(150) NOT NULL,
  		`project_animenewsnetwork_manga` varchar(150) NOT NULL,
  		`project_animenfo` varchar(150) NOT NULL,
  		`project_mangahelpers` varchar(150) NOT NULL,
  		`project_bakaupdates` varchar(150) NOT NULL,
  		`project_mangaupdates` varchar(150) NOT NULL,
  		`project_vndb` varchar(150) NOT NULL,
  		`project_vnet` varchar(150) NOT NULL,
  		`project_animeaddicts` varchar(150) NOT NULL,
  		`project_animgo` varchar(150) NOT NULL,
  		`project_mangahu` varchar(150) NOT NULL,
  		`project_team_leader` int(11) NOT NULL,
  		`project_translator` varchar(50) NOT NULL,
  		`project_translator_other` varchar(100) NOT NULL,
  		`project_karaoke` varchar(50) NOT NULL,
  		`project_karaoke_other` varchar(100) NOT NULL,
  		`project_format` varchar(50) NOT NULL,
  		`project_format_other` varchar(100) NOT NULL,
  		`project_manga_format` VARCHAR( 50 ) NOT NULL,
		`project_manga_format_other` VARCHAR( 150 ) NOT NULL,
  		`project_video` varchar(50) NOT NULL,
  		`project_video_other` varchar(100) NOT NULL,
  		`project_lector` varchar(50) NOT NULL,
  		`project_lector_other` varchar(100) NOT NULL,
  		`project_timer` varchar(50) NOT NULL,
  		`project_timer_other` varchar(100) NOT NULL,
  		`project_date_start` int(11) NOT NULL,
  		`project_date_end` int(11) NOT NULL,
  		`project_download_manga` int(11) NOT NULL,
  		`project_download_anime` int(11) NOT NULL,
  		`project_download_subtitle` int(11) NOT NULL,
  		`project_forum` int(11) NOT NULL,
	) ENGINE=MyISAM ;",
	"CREATE TABLE `".MPREFIX."hotn_animelist_category` (
		`project_id` INT NOT NULL ,
		`category_name` VARCHAR( 20 ) NOT NULL
		`category_image` VARCHAR( 50 ) NOT NULL
	) ENGINE = MYISAM ;"
);

/*
 
 */
?>